<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Using BizBlox Builder</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
body /* This body tag requires the use of one of the sets of banner and/or text div ids */
	{
	margin: 15px;
	padding: 0px 0px 0px 0px;
	background: #ffffff; 
	color: #000000;
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 70%;
	width: 100%;
	/*overflow: expression('hidden');*/
	}
	
pre {
	font-size:11px;
}

h1 {
	color:maroon;
	border-bottom:1px solid silver;
	margin-bottom: 20px;
}
h2 {
	border-bottom:1px solid silver;
	margin-top:25px;
}

h4 {
	font-size:120%;
}
</style>

</head>

<body>
<h1>BizBlox Builder</h1>
<h2>Using BizBlox Builder</h2>
<h3> Prerequisites: </h3>
<p>Before running the BizBlox Builder Import, you must have designed your database structure, and created a SQL script reflecting that structure.</p>
<p>Both are most easily done in SQL Server 2000 Enterprise Manager.</p>
<p>You can create a new database by navigating to your instance of SQL Server, right-clicking on the Databases folder, and selecting:</p>
<pre>Create New Database 
</pre>
<h4>  Generate SQL Script in SQL Server 2000 Enterprise Manager </h4>
<p>When you are finished creating and designing your database, right-click on it in SQL Server 2000 Enterprise Manager, and select:</p>
<pre>Generate SQL Script
</pre>
<p>Alternatively, you can select the database, and choose from the top menu:</p>
<pre>Tools &gt; Generate SQL Script</pre>
<p>The <em>Generate SQL Scripts</em> dialog will appear.</p>
<p>In the <em>General </em>tab, select all of the tables in your database which you want to create class files from. To select all, click <em>Show All </em>and <em>Script all objects</em>.</p>
<p>In the <em>Formatting</em> tab, select all checkboxes except for <em>Only script 7.0 compatible features.</em></p>
<p>In the Options tab, un-check the top 4 checkboxes (from <em>Script database</em> to <em>Script object-level permissions</em>), but check all 4  middle checkboxes (<em>Script indexes</em>, <em>Script full-text indexes</em>, <em>Script triggers</em>, and <em>Script PRIMARY keys, FOREIGN keys,defaults and Check Constraints</em>). You can leave the bottom options as they are, and then click <em>OK</em>. </p>
<p>Select a file name, and click <em>Save</em>. </p>
<p>You now have your SQL script, and are ready to start importing.</p>
<h3>Perform the Import </h3>
<p>Open the Windows Start Menu, and select:</p>
<p>Start &gt; All Programs &gt; Pixolut Industries &gt; BizBlox &gt; BizBlox Builder</p>
<p>There are now just 3 steps to generate your .NET class files. </p>
<h4>Step 1</h4>
<p>Click the button:</p>
<pre>Step 1: Select SQL File 
</pre>
<p>Browse for and select the SQL file that you have created (as described above).</p>
<h4>Step 2 </h4>
<p>Click the button:</p>
<pre>Step 1: Select Target Path</pre>
<p>Select the path where you want to create the new .NET class files.</p>
<p>This will most likely be a folder within your Visual Studio Project. </p>
<p>If you have previously run the BizBlox Builder Import Tool for your project, select the folder where your existing class files are located. </p>
<h4>Step 3 </h4>
<p>Before performing the Import, review the Options in the middle of the window. </p>
<p>Under <em>SQL to Code Generation Options</em>, check all three checkboxes:</p>
<ul>
  <li>Render Data Objects</li>
  <li>Render DOCollections</li>
  <li>Render Transfer Objects   </li>
</ul>
<p>Under <em>Language Options</em>, select the language which you want to create your class files in:</p>
<ul>
  <li>VB.Net 1.1</li>
  <li>C# 1.1 </li>
</ul>
<p>When you are satisfied with the Options, click <em>Step 3: Perform Import.</em></p>
<p>Your .NET class files will now be created (or updated) within seconds. </p>
<p>If you are creating new files, simply add them to your Visual Studio Project.</p>
<p> If you are updating files, Visual Studio will automatically recognise the changes in the files.</p>
</body>
</html>
